package com.jrzh.db.migration.sys;

import com.jrzh.framework.migration.BaseMigration;
import com.jrzh.framework.migration.MigrationHelper;

public class Migration_22 extends BaseMigration{

	private static final String TABLE_NAME = "sys_user_settings";
	
	@Override
	public void down() {
		MigrationHelper.dropTable(TABLE_NAME);
	}

	@Override
	public void up() {
		log.info("##########执行Sys模块 Migration_22##########Begin");
		table(TABLE_NAME, "管理员设置表", true, 
				pk(),
				jrVarchar("_user_id", "关联UserId", 64),
				jrVarchar("_key", "配置Key", 64),
				jrVarchar("_value", "配置值", 512),
				jrVarchar("_remark", "备注", 1024)
		);
		log.info("##########执行Sys模块 Migration_22##########End");
	}

}
